How to: Create a field that finds and displays values from another field.

Solution:


In the Table Design view, insert the field, and type a name for the field. Then select 'Lookup Wizard...' from the drop-down list in the 'Data Type' column, and follow the instructions.